﻿CREATE TABLE [dbo].[ElectorateOffices] (
    [AddressLine1]           NVARCHAR (100) NULL,
    [AddressLine2]           NVARCHAR (100) NULL,
    [Suburb]                 NVARCHAR (50)  NULL,
    [State]                  NVARCHAR (4)   NULL,
    [PostCode]               NVARCHAR (4)   NULL,
    [PrincipalOffice]        BIT            NULL,
    [Telephone]              NVARCHAR (50)  NULL,
    [Fax]                    NVARCHAR (50)  NULL,
    [PostalAddress]          NVARCHAR (100) NULL,
    [PostalSuburb]           NVARCHAR (50)  NULL,
    [PostalState]            NVARCHAR (4)   NULL,
    [PostalPostCode]         NVARCHAR (4)   NULL,
    [Id]                     INT            NOT NULL,
    [Parliamentarian_CPALId] INT            NOT NULL
);

